<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
<?php
header('Content-type: text/html; charset=utf-8');
?>
<?php
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "db_shop";

 $conn=mysqli_connect( $mysql_server_name,$mysql_username,$mysql_password);
 mysqli_query ($conn, "set names 'utf-8'");

    
	
$sql = "select * from custom";
	//require_once('page.php');
	//page($sql,'room.php',"5");//这里是分页的句子
	//$sql = " SELECT * FROM room ORDER BY room_id DESC limit".$begincount.",".$rows; 
    mysqli_select_db($conn, $mysql_database);
   $result=mysqli_query( $conn, $sql);

?>
<body>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30"><table width="778" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="24" bgcolor="#6699ff"><table width="778" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td bordercolor="#0072FF"><table width="778" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="6%" height="19" valign="bottom"><div align="center"></div></td>
                <td width="94%" valign="bottom"><span class="STYLE1">房客信息</span></td>
              </tr>
            </table></td>
            <td><div align="right"><span class="STYLE1">&nbsp;</span><span class="STYLE1"> &nbsp;</span></div></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <form name="form" method="post"   onsubmit="return check();" action="customchaxun.php">

	   <tr> <td colspan="6" bgcolor="#FFFFFF">请输入要查找的房客的名字关键字：<input name="name" type="text" />
	     <label>
	     <input type="submit" name="Submit" value="进行搜索" />
	     </label></td></tr>
		 
		 </form>
  <tr>
    <td bordercolor="#FFFFFF"><table width="778" border="0" cellpadding="0" cellspacing="1" bgcolor="#a8c7ce">
	<tr>
        
        <td width="8%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">姓名</span></div></td>
        <td width="5%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">性别</span></div></td>
        <td width="5%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">年龄</span></div></td>
        <td width="6%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">֤证件类型</span></div></td>
        <td width="9%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">֤证件编号</span></div></td>
        <td width="6%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">会员编号</span></div></td>
		 <td width="12%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">入住时间</span></div></td>
		 <td width="12%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">退房时间</span></div></td>
		 <td width="5%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">入住人数</span></div></td>
		 <td width="7%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间编号</span></div></td>
		 <td width="7%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间价格</span></div></td>
		 <td width="7%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">押金</span></div></td>
		 <td width="5%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">折扣</span></div></td>
		 <td width="13%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">操作</span></div></td>
      </tr>
	  
	  <?php
	  while($row =mysqli_fetch_array($result))
{

 ?>
  
	<tr>

        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['name'];?></div></td>

		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['gender'];?></div></td>

        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['age'];?></div></td>
        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['document_type'];?></div></td>
        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['document_id'];?></div></td>
        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['member_id'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['check_time'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['check_out_time'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['check_num'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_id'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_cost'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['deposit'];?></div></td>
		<!-- <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['enjoy_benefits'];?></div></td>-->
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><a href="customupdate.php?id=<?php echo $row['document_id'];?>">�޸�</b></a><a href="custom_delete.php?id=<?php echo $row['document_id'];?>">ɾ��</a></div></td>
      </tr>

	  <?php
	  }
	  ?>
	 
    </table></td>
  </tr></body>
</html>
<body>
</body>
</html>